almost 1,000 personnel required psychiatric treatment after taking drug .
they were prescribed anti-malarial drug lariam by the ministry of defence .
the product 's side effects include psychosis and hallucinations .
retired major general alastair duncan is currently in a psychiatric unit .
he was prescribed the drug prior to a deployment in sierra leone .